﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Collections;
using System.Data;
using PTTK19.BUS;
using System.Data.SqlClient;

namespace PTTK19.DB
{
    class DB_PhieuYeuCau
    {
        public static DataTable LayDanhSachMaPYC()
        {
            DataTable ds = new DataTable();
            DBMS dbms = new DBMS();
            dbms.Connect();
            string sql = "SELECT MaPhieuYC FROM PhieuYeuCau WHERE TinhTrang =0";
            dbms.Connect();
            ds = dbms.ExcuteQueryTable(sql);
            dbms.Disconnect();
            return ds;
        }
        public static DataSet LayDanhSachMaPYC1()
        {
            DataSet ds = new DataSet();
            DBMS dbms = new DBMS();
            dbms.Connect();
            string sql = "SELECT MaPhieuYC FROM PhieuYeuCau";
            dbms.Connect();
            ds = dbms.ExcuteQueryDataSet(sql);
            dbms.Disconnect();
            return ds;
        }
    }
}
